package mypage;

import common.db.*;
import common.main.*;

public class BonusCheckBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String id = (String)inputTable.get("id");
		
		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT a.SEQ, b.NAME, TO_CHAR(a.START_DATE, 'YYYY-MM-DD') START_DATE, TO_CHAR(a.END_DATE, 'YYYY-MM-DD') END_DATE, a.POINT FROM BONUS a, ORDERLIST b ");
		queryBuffer.append("WHERE ID='"+id+"' AND USE_YN = 'Y' AND a.MAGIC_SEQ = b.SEQ");
			
		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}
